Brasil DCI Frequency vs Severity ¶
Description: This python code extract the information of DCI brasil, and clean it in a proper way.
shape: (11, 9)
| coverage | NúmeroPolizas | NúmeroSiniestros | IncurridoTotal | frecuencia | severidad | PrimaTotal | PrimaPura | lossRatio |
|---|---|---|---|---|---|---|---|---|
| str | i32 | i64 | f64 | f64 | f64 | f64 | f64 | f64 |
| "THEFT" | 64,714 | 2,214 | 14,938,618.2 | 0.0 | 6,747.3 | 32,370,048.3 | 160.2 | 216.7 |
| "WINDSTORM" | 94,980 | 3,034 | 39,081,967.4 | 0.0 | 12,881.3 | 29,820,150.6 | 380.9 | 76.3 |
| "FLOOD" | 8,843 | 310 | 6,853,157.2 | 0.0 | 22,107.0 | 2,901,650.9 | 607.1 | 42.3 |
| "ELECTRICAL DAMAGE" | 112,910 | 6,055 | 73,864,605.0 | 0.0 | 12,198.9 | 25,822,697.9 | 604.0 | 35.0 |
| "EQUIPMENT DAMAGE" | 46 | 46 | 440,120.8 | inf | 9,567.8 | 0.0 | inf | 0.0 |
| "STRCC" | 5 | 5 | 105,231.6 | inf | 21,046.3 | 0.0 | inf | 0.0 |
| "WATER DAMAGE" | 58,155 | 1,798 | 14,539,993.1 | 0.0 | 8,086.8 | 12,175,569.3 | 205.2 | 83.7 |
| "FIRE" | 119,981 | 2,054 | 63,982,449.9 | 0.0 | 31,150.2 | 111,817,092.8 | 236.5 | 174.8 |
| "OTHER" | 101,257 | 2,066 | 12,686,436.6 | 0.0 | 6,140.6 | 26,883,443.6 | 51.9 | 211.9 |
| "GL" | 98,283 | 1,589 | 14,604,097.9 | 0.0 | 9,190.7 | 49,113,072.9 | 47.6 | 336.3 |
| "WORK DAMAGE" | 17 | 0 | 0.0 | 0.0 | NaN | 18,886.6 | NaN | inf |
THEFT:
WINDSTORM:
FLOOD:
ELECTRICAL DAMAGE:
EQUIPMENT DAMAGE:
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
STRCC:
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\plotting\plot.py:1348: RuntimeWarning: invalid value encountered in scalar subtract yspan = y1-y0 if util.is_number(y0) and util.is_number(y1) else None c:\Users\ABGUERR\AppData\Local\anaconda3\Lib\site-packages\holoviews\core\util.py:1069: RuntimeWarning: invalid value encountered in scalar subtract span = (upper-lower)
WATER DAMAGE:
FIRE:
OTHER:
GL:
WORK DAMAGE: